This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
~Dexter Nonnuader 3.Dec.03 02:41 PM a Web browser Domino Designer6.0.1 CF1All Platforms
I have a document (Form A) with a dialoglist field with the following formula:
@DbLookup("Notes":"NoCache";@DbName;"relations";ww_r_name;2).
This does a lookup in a view "relations" (with "relation"-documents, (Form B)), looking for the value in the field "ww_w_name".
It happens sometimes that I first have to add a new "relations"-document (Form B) to the view "relations", so that I can select it in the dialogist field. So, I have added an form-action to Form A to create a new "relations"-document (form B) in the "relations"-view. In the QuerySave-Event of form B, I added LS-code the update the FT-index of the database, and to refresh the backend-view "relations".
But I have to close the new document (form A) first and to reopen it the get the newly created document (form B) in the dialoglist field.
The property in the dialoglist field "Add Values Not In List" is not an option, bacause the selections in the dialoglist-field should be complete documents, not only names or values.
How can I get the newly created document in the dialoglist field immediatly after creating a document in the view to which the dblookup was performed? I tried the DBLookup options Recache and NoCache.